PROJECT DESCRIPTION
|
Beer is the worlds most widely consumed alcoholic beverage; it is the third most popular drink overall, after water and tea. It is thought by some to be the oldest fermented beverage. Beer is produced by the saccharification of starch and fermentation of the resulting sugar. The starch and saccharification enzymes are often derived from malted cereal grains, most commonly malted barley and malted wheat. Unmalted maize and rice are widely used adjuncts to lighten the flavor because of their lower cost. The preparation of beer is called brewing. Most beer is flavoured with hops, which add bitterness and act as a natural preservative, though other flavourings such as herbs or fruit may occasionally be included. Some of humanity's earliest known writings refer to the production and distribution of beer: the Code of Hammurabi included laws regulating beer and beer parlours, and The Hymn to Ninkasi, a prayer to the Mesopotamian goddess of beer, served as both a prayer and as a method of remembering the recipe for beer in a culture with few literate people. Today, the brewing industry is a global business, consisting of several dominant multinational companies and many thousands of smaller producers ranging from brewpubs to regional breweries. The strength of beer is usually around 4% to 6% alcohol by volume (abv) although it may vary between 0.5% (de alcoholized) and 20%, with some breweries creating examples of 40% abv and above in recent years. Beer forms part of the culture of beer drinking nations and is associated with social traditions such as beer festivals, as well as a rich pub culture involving activities like pub crawling and pub games such as bar billiards. Nutritional Aspects of Beer Beer is a not unimportant component of the diet. The alcohol in beer provides calories and influences the consumption of other nutrients. The energy value of alcohol is 7 kcal/g. Four 25 cl glasses of lager (around 40 g of alcohol) provide as many calories as 70 g of sugar. Four glasses of a soft drink, coke for example, contain as many calories as 132 g of sugar. This is around twice as much as four glasses of lager. But there is something special about the energy value of alcohol. Market Survey Liquor industry has always remained under strict governmental control in terms of capacity creation, distribution, taxation. While overall public perception spells restraint, it is the symbol of high life even in puritan India. The industry poses a dilemma to the state. It cannot resist the temptation of large revenues, while steering clear of the embarrassment of giving encouragement to drinking. A positive feature of allowing the industry to grow and operate is the prevention of illicit production and drinking. Of the over Rs 280 bn liquor industry (excluding beer) selling around 450 mn cases annually, a large peg of which (67%) is whisky, followed by brandy and gin at 13%, rum at 17% while the white spirits account for 3% of the market share. Of this, the Indian made foreign liquor (IMFL) accounts for Rs 78 bn (86 mn cases) with whisky alone constituting 95%. Besides, there is a large 223 mn case market of low priced country liquor. Indian spirit market also consumes branded country liquor worth Rs 125 bn and unbranded country liquor worth Rs 50 bn. A feather in India's alcoholic drinks industry is that India's McDowell's No.1 brandy has emerged as the highest selling brandy globally, pushing the world famous E&J Gallo to the second spot. Other global majors at the top included Presidente brandy (Allied Domecq), Wilyhever Goldkrone (Graflich von Hardenberg'sche Kornbrennerei) and Chantre (Eckes) occupying the next three spots among the top five. India has quietly emerged as the largest international whisky market, toppling the US by volume. Industry data indicate that Indian whiskies, non matured alcohols mostly made from molasses, and hence not considered whisky by the Scotch Whisky Association (SWA), reported sales of about 60 mn cases (9 litre each). In comparison, the US recorded combined sales of Bourbon, American and Scotch whiskies at 48 50 mn cases, putting it one notch below India. Indian whiskies account for 98% of domestic whisky consumption, registering over10% growth annually, which makes it one among the fastest growing whisky markets anywhere in the world. Few Indian Major Players are as Under: Allied Blenders & Distillers Pvt. Ltd. Amber Distilleries Ltd. Amrut Distilleries Ltd. Arlem Breweries Ltd. [Merged] Arthos Breweries Ltd. Associated Breweries & Distilleries Ltd. [Merged] Aurangabad Breweries Ltd. B D A Breweries & Distilleries Ltd. B D A Pvt. Ltd. Bacardi India Pvt. Ltd. Balaji Distilleries Ltd. [Merged] Balbir Distilleries Ltd. [Merged] Baramati Grape Inds. Ltd. [Merged] Beam Global Spirits & Wine (India) Pvt. Ltd. Blossom Industries Ltd. Buckingham Distilleries & Breweries Ltd. [Merged] Castle Breweries Ltd. Central Distillery & Breweries Ltd. [Merged] Charminar Breweries Ltd. [Merged] Charosa Wineries Ltd. Cobra Indian Beer Pvt. Ltd. Devans Modern Breweries Ltd. Doburg Lager Breweries Ltd. [Erstwhile] East Coast Breweries & Distilleries Ltd. [Merged] Empee Distilleries Ltd. Foster'S India Ltd. Four Seasons Wines Ltd. Glasgow Distilleries Ltd. Grover Vineyards Ltd. Haryana Breweries Ltd. [Merged] High Range Breweries Ltd. [Merged] Hindustan Breweries & Bottling Ltd. Hyderabad Distilleries & Wineries Ltd. Impala Distillery & Brewery Ltd. Indage Vintners Ltd. Indo Lowenbrau Breweries Ltd. [Merged] Interlink Exports Ltd. Jagatjit Industries Ltd. John Distilleries Ltd. Jubilee Beverages Ltd. Kalyani Breweries Ltd. [Merged] Kedia Distilleries Ltd. Kerala Alcoholic Products Ltd. Kerala Distilleries & Allied Products Ltd. [Merged] Kesarval Beverages Ltd. [Merged] Khemani Distilleries Pvt. Ltd. Kool Breweries Ltd. Lilasons Breweries Ltd. Lilasons Industries Ltd. Malabar Breweries Ltd. [Merged] Mangalore Breweries & Distilleries Ltd. [Merged] Mcdowell & Co. Ltd. [Merged] Mehra Beverages Ltd. [Merged] Millennium Beer Inds. Ltd. [Merged] Mohan Breweries & Distilleries Ltd. Mohan Meakin Ltd. Mohan Rocky Springwater Breweries Ltd. Mount Shivalik Breweries Ltd. Mount Shivalik Inds. Ltd. Mysore Breweries Ltd. [Merged] Mysore Wine Products Ltd. [Merged] Pals Distilleries Ltd. Pernod Ricard India Pvt. Ltd. Piccadily Sugar & Allied Inds. Ltd. Pincon Spirit Ltd. Prag Distillery Pvt. Ltd. Premier Breweries Ltd. [Merged] Punjab Breweries Ltd. [Merged] Radico Khaitan Ltd. Rainbow Breweries Ltd. Rairu Distilleries Ltd. Raj Breweries Ltd. [Merged] Rajasthan Breweries Ltd. Ravikumar Distilleries Ltd. Rochees Breweries Ltd. [Merged] Salamander Distillers Ltd. [Merged] Seagram Distilleries Pvt. Ltd. Shaw Wallace & Co. Ltd. [Merged] Shaw Wallace Distilleries Limited [Merged] Shaw Wallace Distilleries Ltd. [Merged] Shiva Distilleries Ltd. Sica Breweries Ltd. [Merged] Silver Oak (India) Ltd. Skol Breweries Ltd. Skol Breweries Ltd. [Merged] Som Distilleries & Breweries Ltd. Southern Agrifurane Inds. Ltd. Southern Agrifurane Inds. Ltd. [Merged] Tilaknagar Distilleries & Inds. Ltd. [Merged] Tilaknagar Industries Ltd. Travancore Sugars & Chemicals Ltd. Tripti Alcobrew Ltd. United Breweries Ltd. Utkal Distilleries Ltd. V R V Breweries & Bottling Inds. Ltd. [Merged] Vinayak Distilleries Ltd. Vinedale Distilleries Ltd. Vitari Distilleries Ltd. [Merged] Winsome Breweries Ltd. Xylon Loquitur Distillers & Vintners Ltd. Cost Estimation Capacity : 92307 Beer Bottles/ day 5333 Wine Bottles/ day 5333 Whisky Bottles/ day
|
PROJECT AT A GLANCE
| COST OF PROJECT |
MEANS OF FINANCE |
| Particulars |
Existing |
Proposed |
Total |
Particulars |
Existing |
Proposed |
Total |
| Land & Site Development Exp. |
********** |
********** |
********** |
Capital |
********** |
********** |
********** |
| Buildings |
********** |
********** |
********** |
Share Premium |
********** |
********** |
********** |
| Plant & Machineries |
********** |
********** |
********** |
Other Type Share Capital |
********** |
********** |
********** |
| Motor Vehicles |
********** |
********** |
********** |
Reserves & Surplus |
********** |
********** |
********** |
| Office Automation Equipments |
********** |
********** |
********** |
Cash Subsidy |
********** |
********** |
********** |
| Technical Knowhow Fees & Exp. |
********** |
********** |
********** |
Internal Cash Accruals |
********** |
********** |
********** |
| Franchise & Other Deposits |
********** |
********** |
********** |
Long/Medium Term Borrowings |
********** |
********** |
********** |
| Preliminary& Pre-operative Exp |
********** |
********** |
********** |
Debentures / Bonds |
********** |
********** |
********** |
| Provision for Contingencies |
********** |
********** |
********** |
Unsecured Loans/Deposits |
********** |
********** |
********** |
| Margin Money - Working Capital |
********** |
********** |
********** |
|
********** |
********** |
********** |
| TOTAL |
********** |
********** |
********** |
TOTAL |
********** |
********** |
********** |
COST OF PROJECT
| Particulars |
Existing |
Proposed |
Total |
| C O S T O F P R O J E C T |
|
|
|
| Land & Site Development Exp. |
|
|
|
| Land Area Required |
********** |
********** |
********** |
| Land Development Cost, Boundary Wall, Gate & Road etc. |
********** |
********** |
********** |
|
|
********** |
********** |
********** |
| Buildings |
********** |
********** |
********** |
| Factory Building - |
********** |
********** |
********** |
| Office Buildings |
********** |
********** |
********** |
|
|
********** |
********** |
********** |
| Plant & Machineries |
********** |
********** |
********** |
| Indigenous Machineries |
********** |
********** |
********** |
| Erection & Installation |
********** |
********** |
********** |
| Laboratory Equipments |
********** |
********** |
********** |
|
Miscellaneous Equipments like pumps, valves, pipeline & fittings
|
********** |
********** |
********** |
| Imported Machineries |
********** |
********** |
********** |
| Technical know how |
********** |
********** |
********** |
|
********** |
********** |
********** |
| Office Vehicles |
********** |
********** |
********** |
| Office Automation Equipments (Telephone/ Fax/ Computer) |
********** |
********** |
********** |
|
Office Equipment, Furniture plus Other Equipment & Accessories
|
********** |
********** |
********** |
| Other Misc. Assets |
********** |
********** |
********** |
| Pre-operative & Preliminary Expenses |
********** |
********** |
********** |
| Provision for Contingencies |
********** |
********** |
********** |
|
********** |
********** |
********** |
| Total Capital Cost of Project |
********** |
********** |
********** |
| Margin Money for Working Capital |
********** |
********** |
********** |
| Total Cost of Project |
********** |
********** |
********** |
PROFITABILITY AND NET CASH ACCRUALS
| Particulars |
Operating Years
|
|
1-2
|
2-3
|
3-4
|
4-5
|
5-6
|
|
********** |
********** |
********** |
********** |
********** |
| Revenue/Income/Realisation |
********** |
********** |
********** |
********** |
********** |
| Gross Sales Realisation |
********** |
********** |
********** |
********** |
********** |
| Less : Excise Duties/Levies |
********** |
********** |
********** |
********** |
********** |
| Net Sales Realisation |
********** |
********** |
********** |
********** |
********** |
| Total Revenue/Income/Realisation |
********** |
********** |
********** |
********** |
********** |
|
********** |
********** |
********** |
********** |
********** |
| Expenses/Cost of Products/Services/Items |
********** |
********** |
********** |
********** |
********** |
| Raw Material Cost |
********** |
********** |
********** |
********** |
********** |
| Indigenous |
********** |
********** |
********** |
********** |
********** |
| Total Nett Consumption |
********** |
********** |
********** |
********** |
********** |
| Lab & ETP Chemical Cost |
********** |
********** |
********** |
********** |
********** |
| Packing Material Cost |
********** |
********** |
********** |
********** |
********** |
| Sub Total of Net Consumption |
********** |
********** |
********** |
********** |
********** |
| Miscellaneous Cost |
********** |
********** |
********** |
********** |
********** |
| Employees Expenses |
********** |
********** |
********** |
********** |
********** |
| Fuel Expenses |
********** |
********** |
********** |
********** |
********** |
| Power/Electricity Expenses |
********** |
********** |
********** |
********** |
********** |
| Depreciation |
********** |
********** |
********** |
********** |
********** |
| Royalty & Other Charges |
********** |
********** |
********** |
********** |
********** |
| Repairs & Maintenance Exp. |
********** |
********** |
********** |
********** |
********** |
| Other Mfg. Expenses |
********** |
********** |
********** |
********** |
********** |
| Cost of Output of Goods Sold |
********** |
********** |
********** |
********** |
********** |
|
********** |
********** |
********** |
********** |
********** |
| Gross Profit |
********** |
********** |
********** |
********** |
********** |
| Administration Expenses |
********** |
********** |
********** |
********** |
********** |
| Technical Knowhow Fees & Exp. |
********** |
********** |
********** |
********** |
********** |
| Financial Charges |
********** |
********** |
********** |
********** |
********** |
| Long/Medium Term Borrowing |
********** |
********** |
********** |
********** |
********** |
| On Wkg. Capital Borrowings |
********** |
********** |
********** |
********** |
********** |
| Total Financial Charges |
********** |
********** |
********** |
********** |
********** |
| Selling Expenses |
********** |
********** |
********** |
********** |
********** |
| Total Cost of Sales |
********** |
********** |
********** |
********** |
********** |
|
********** |
********** |
********** |
********** |
********** |
| Net Profit Before Taxes |
********** |
********** |
********** |
********** |
********** |
| Tax on Profit |
********** |
********** |
********** |
********** |
********** |
| Net Profit After Taxes |
********** |
********** |
********** |
********** |
********** |
| Depreciation Added Back |
********** |
********** |
********** |
********** |
********** |
| Technical Knowhow Fees & Exp. |
********** |
********** |
********** |
********** |
********** |
| Net Cash Accruals |
********** |
********** |
********** |
********** |
********** |
ASSSESSEMENT OF WORKING CAPITAL REQUIREMENTS
| Particulars |
Stk.Prd. |
Stk.Prd. |
|
Operating Years |
|
1st Year |
2nd Yr&+ |
|
1-2 |
2-3 |
3-4 |
4-5 |
5-6 |
| Capacity |
Months |
Months |
% |
********** |
********** |
********** |
********** |
********** |
| CURRENT ASSETS |
|
|
|
********** |
********** |
********** |
********** |
********** |
| Stocks on Hand |
|
|
|
********** |
********** |
********** |
********** |
********** |
| Raw Material Cost |
|
|
|
********** |
********** |
********** |
********** |
********** |
| Indigenous |
********** |
********** |
M |
********** |
********** |
********** |
********** |
********** |
| Lab & ETP Chemical |
********** |
********** |
M |
********** |
********** |
********** |
********** |
********** |
| Packing Material |
********** |
********** |
M |
********** |
********** |
********** |
********** |
********** |
| Consumable Store |
********** |
********** |
M |
********** |
********** |
********** |
********** |
********** |
| Work-in-Process |
********** |
********** |
D |
********** |
********** |
********** |
********** |
********** |
| Finished Goods |
********** |
********** |
M |
********** |
********** |
********** |
********** |
********** |
| Current Expenses |
********** |
********** |
M |
********** |
********** |
********** |
********** |
********** |
| Receivables |
********** |
********** |
M |
********** |
********** |
********** |
********** |
********** |
|
********** |
********** |
|
********** |
********** |
********** |
********** |
********** |
| Total |
|
|
|
********** |
********** |
********** |
********** |
********** |
| Cash/Bank Balances |
|
|
|
********** |
********** |
********** |
********** |
********** |
| Gross Wkg. Capital |
|
|
|
********** |
********** |
********** |
********** |
********** |
|
|
|
|
********** |
********** |
********** |
********** |
********** |
|
|
|
|
|
|
|
|
|
PROFITABILITY RATIOS, DSCR, DEBT EQUITY
| Particulars |
|
Operating Years |
|
|
1-2 |
2-3 |
3-4 |
4-5 |
5-6 |
|
|
|
|
|
|
|
| Profit Percentages to Net Sales |
|
|
|
|
|
|
| Gross Profit |
|
********** |
********** |
********** |
********** |
********** |
| % Of G.P. to Net Sales |
|
********** |
********** |
********** |
********** |
********** |
| Net Profit Before Taxes |
|
********** |
********** |
********** |
********** |
********** |
| % of N.P.B.T. To Net Sales |
|
********** |
********** |
********** |
********** |
********** |
| Net Profit After Taxes |
|
********** |
********** |
********** |
********** |
********** |
| % of N.P.A.T. To Net Sales |
|
********** |
********** |
********** |
********** |
********** |
|
|
|
|
|
|
|
| Debt Service Coverage Ratio |
|
|
|
|
|
|
| Funds Available to Service Debts |
|
|
|
|
|
|
| Net Profit After Taxes |
|
********** |
********** |
********** |
********** |
********** |
| Depreciation Charges |
|
********** |
********** |
********** |
********** |
********** |
| Technical Knowhow Fees & Exp |
|
********** |
********** |
********** |
********** |
********** |
| Interest on Long/Medium Term |
|
********** |
********** |
********** |
********** |
********** |
| T o t a l |
|
********** |
********** |
********** |
********** |
********** |
| Debt Service Obligations |
|
|
|
|
|
|
| Repayment of Long/Medium Ter |
|
********** |
********** |
********** |
********** |
********** |
| Interest on Long/Medium Term |
|
********** |
********** |
********** |
********** |
********** |
| T o t a l |
|
********** |
********** |
********** |
********** |
********** |
|
|
|
********** |
********** |
********** |
********** |
********** |
| D. S. C. R. (Individual) |
|
********** |
********** |
********** |
********** |
********** |
| D. S. C. R. (Cumulative) ..... |
|
********** |
********** |
********** |
********** |
********** |
| D. S. C. R. (Overall) ........ |
|
********** |
********** |
********** |
********** |
********** |
|
|
|
|
|
|
|
| Parameters |
|
|
|
|
|
|
| Initial Equity Capital |
********** |
********** |
********** |
********** |
********** |
********** |
| Credit Balance in P & L |
********** |
********** |
********** |
********** |
********** |
********** |
| Total Capital excl Unsec Deposits |
********** |
********** |
********** |
********** |
********** |
********** |
| Unsecured Dep. |
********** |
********** |
********** |
********** |
********** |
********** |
| Total Equity incl Unsecured Deposits |
********** |
********** |
********** |
********** |
********** |
********** |
| Long/Medium Term Borrowings from Bank |
********** |
********** |
********** |
********** |
********** |
********** |
| Term lia. Incl Unsecured Deposit |
********** |
********** |
********** |
********** |
********** |
********** |
| Total Liabilities |
********** |
********** |
********** |
********** |
********** |
********** |
| Total Liabilities incl Unsecured Deposits |
********** |
********** |
********** |
********** |
********** |
********** |
| DEBT EQUITY RATIO considering |
|
|
|
|
|
|
| i.e.Total Term Lia./NW |
|
|
|
|
|
|
| Unsecured Dep. as Equity |
********** |
********** |
********** |
********** |
********** |
********** |
| Unsecured Dep. as Debt |
********** |
********** |
********** |
********** |
********** |
********** |
| Total Outside Lia./NW |
|
********** |
********** |
********** |
********** |
********** |
| Assets Turnover Ratio (x) |
|
********** |
********** |
********** |
********** |
********** |
|
|
|
|
|
|
|
| No. of Shares of 10.00 each |
|
********** |
********** |
********** |
********** |
********** |
| Earnings Per Share (EPS) (in `) |
|
********** |
********** |
********** |
********** |
********** |
| Proposed divident |
|
********** |
********** |
********** |
********** |
********** |
| Cash EPS (in `) |
|
********** |
********** |
********** |
********** |
********** |
| Dividend Per Share(DPS) (in `) |
|
********** |
********** |
********** |
********** |
********** |
| Payout Ratio (%Age) |
|
********** |
********** |
********** |
********** |
********** |
| Retained Earnings/Share (in `) |
|
********** |
********** |
********** |
********** |
********** |
| Retained Earnings (%Age) |
|
********** |
********** |
********** |
********** |
********** |
| Book Value Per Share (in `) |
|
********** |
********** |
********** |
********** |
********** |
| Debt Per Share (in `) |
|
********** |
********** |
********** |
********** |
********** |
| Probable Mkt.Price/Share(in `) |
|
********** |
********** |
********** |
********** |
********** |
| Price / Book Value (x) |
|
********** |
********** |
********** |
********** |
********** |
| Price Earnings Ratio (x) |
|
********** |
********** |
********** |
********** |
********** |
| Yield (%Age) |
|
********** |
********** |
********** |
********** |
********** |
BREAK EVEN ANALYSIS
| Particulars |
|
Operating Years |
|
Ratio |
1-2 |
2-3 |
3-4 |
4-5 |
5-6 |
|
|
|
|
|
|
|
| BREAK EVEN ANALYSIS |
|
|
|
|
|
|
| Total Value of Output |
|
********** |
********** |
********** |
********** |
********** |
|
|
|
|
|
|
|
|
| Variable Cost & Expenses |
|
|
|
|
|
|
| Raw Material Cost |
********** |
********** |
********** |
********** |
********** |
********** |
| Lab & ETP Chemical Cost |
********** |
********** |
********** |
********** |
********** |
********** |
| Packing Material Cost |
********** |
********** |
********** |
********** |
********** |
********** |
| Sales Commission/Exp. |
********** |
********** |
********** |
********** |
********** |
********** |
| Sub-total |
|
********** |
********** |
********** |
********** |
********** |
| Less:W.I.P. Adjustments |
|
********** |
********** |
********** |
********** |
********** |
| Total Variable Cost |
|
********** |
********** |
********** |
********** |
********** |
| Net Contribution |
|
********** |
********** |
********** |
********** |
********** |
| Profit Volume Ratio (%) |
|
********** |
********** |
********** |
********** |
********** |
|
|
|
|
|
|
|
| Semi-Var./Semi-Fixed Exp. |
|
|
|
|
|
|
| Miscellaneous Cost |
********** |
********** |
********** |
********** |
********** |
********** |
| Employees Expenses |
********** |
********** |
********** |
********** |
********** |
********** |
| Power/Electricity Expen |
********** |
********** |
********** |
********** |
********** |
********** |
| Fuel Expenses |
********** |
********** |
********** |
********** |
********** |
********** |
| Royalty & Other Charges |
********** |
********** |
********** |
********** |
********** |
********** |
| Repairs & Maintenance E |
********** |
********** |
********** |
********** |
********** |
********** |
| Other Mfg. Expenses |
********** |
********** |
********** |
********** |
********** |
********** |
| Administration Expenses |
********** |
********** |
********** |
********** |
********** |
********** |
| Selling Expenses |
********** |
********** |
********** |
********** |
********** |
********** |
| Interest on Wkg.Capital |
********** |
********** |
********** |
********** |
********** |
********** |
| Tot.Semi-Var./Fixed Exp. |
|
********** |
********** |
********** |
********** |
********** |
|
|
|
********** |
|
|
|
|
| Fixed Expenses / Cost |
|
********** |
|
|
|
|
| Miscellaneous Cost |
********** |
********** |
********** |
********** |
********** |
********** |
| Employees Expenses |
********** |
********** |
********** |
********** |
********** |
********** |
| Power/Electricity Expen |
********** |
********** |
********** |
********** |
********** |
********** |
| Fuel Expenses |
********** |
********** |
********** |
********** |
********** |
********** |
| Royalty & Other Charges |
********** |
********** |
********** |
********** |
********** |
********** |
| Repairs & Maintenance E |
********** |
********** |
********** |
********** |
********** |
********** |
| Other Mfg. Expenses |
********** |
********** |
********** |
********** |
********** |
********** |
| Administration Expenses |
********** |
********** |
********** |
********** |
********** |
********** |
| Selling Expenses |
********** |
********** |
********** |
********** |
********** |
********** |
| Intrest-Fixed Borrowing |
********** |
********** |
********** |
********** |
********** |
********** |
| Intrest-Working Capital |
********** |
********** |
********** |
********** |
********** |
********** |
| Depreciation Charges |
********** |
********** |
********** |
********** |
********** |
********** |
| Deferred Expenses W/Off |
********** |
********** |
********** |
********** |
********** |
********** |
| Total Fixed Expenses |
|
********** |
********** |
********** |
********** |
********** |
| Tot.Fixed/Semi-Fixed Exp |
|
********** |
********** |
********** |
********** |
********** |
| Tot.Cash Fixed/SemiFixed |
|
********** |
********** |
********** |
********** |
********** |
|
|
|
|
|
|
|
| Cash Break Even Sales |
|
********** |
********** |
********** |
********** |
********** |
| Cash Margin of Safety |
|
********** |
********** |
********** |
********** |
********** |
| Break Even Sales |
|
********** |
********** |
********** |
********** |
********** |
| Margin of safety |
|
********** |
********** |
********** |
********** |
********** |
|
|
|
|
|
|
|
| At Maximum Utilisation : |
Year |
********** |
********** |
********** |
********** |
********** |
| (as % of Installed Capacity) |
|
|
|
|
|
|
| Cash B.E.P. : |
% |
xx% |
xx% |
xx% |
xx% |
xx% |
| B.E.P. : |
% |
xx% |
xx% |
xx% |
xx% |
xx% |
M E A N S O F F I N A N C E
Equity Share Capital |
********** |
********** |
********** |
Others - Preference Share Capital |
********** |
********** |
********** |
| Total Equity Share Capital |
********** |
********** |
********** |
|
********** |
********** |
********** |
Long/Medium Term Borrowings |
********** |
********** |
********** |
| FROM BANK |
********** |
********** |
********** |
| From Other Financial Institutions |
********** |
********** |
********** |
| Total Long/Medium Term Borrowings |
********** |
********** |
********** |
|
********** |
********** |
********** |
|
Total Means of Finance
|
********** |
********** |
********** |
INTEREST AND REPAYMENT ON TERM LOANS
| A |
Name of Institution-Bank |
ABC BANK |
|
|
| B |
Term Borrowing Amount |
********** |
xx |
|
| C |
Repayment Term (Years) |
********** |
Years |
|
| D |
Repayment Instalments |
********** |
Instalments |
|
| E |
Repayment Commencement |
Year - 0; 3rd Qtr. |
|
|
| F |
Rate of Interest(General) |
xxxx% |
p.a. |
|
| F |
Rate of Interest(Initial) |
0.00% |
p.a. |
|
| G |
Apply Gen. Int. Rate from Year |
x Quarter :: x |
|
|
| H |
Interest Calculation |
Quarterly |
|
|
Debt Service Coverage Ratio
| Funds Available to Service Debts |
|
|
|
|
|
|
| Net Profit After Taxes |
|
********** |
********** |
********** |
********** |
********** |
| Depreciation Charges |
|
********** |
********** |
********** |
********** |
********** |
| Technical Knowhow Fees & Expenses |
|
********** |
********** |
********** |
********** |
********** |
| Interest on Long/Medium Term |
|
********** |
********** |
********** |
********** |
********** |
| T o t a l |
|
********** |
********** |
********** |
********** |
********** |
| Debt Service Obligations |
|
********** |
********** |
********** |
********** |
********** |
| Repayment of Long/Medium Term |
|
********** |
********** |
********** |
********** |
********** |
| Interest on Long/Medium Term |
|
********** |
********** |
********** |
********** |
********** |
| T o t a l |
|
********** |
********** |
********** |
********** |
********** |
|
|
|
********** |
********** |
********** |
********** |
********** |
| D. S. C. R. (Individual) |
|
********** |
********** |
********** |
********** |
********** |
| D. S. C. R. (Cumulative) ..... |
|
********** |
********** |
********** |
********** |
********** |
| D. S. C. R. (Overall) ........ |
|
********** |
********** |
********** |
********** |
********** |
DEPRECIATION CHARGES AS PER BOOKS (TOTAL)
| Operating Year |
F.Assets Type A-1 |
F.Assets Type A-2 |
F.Assets Type B |
F.Assets Type C |
F.Assets Type D-1 |
F.Assets Type D-2 |
Total |
| Particulars |
Factory Building - |
Office Buildings |
PLANT & MACHINERY |
Office Vehicles |
Office Automation Equipments (Telephone/ Fax/ Computer)
|
Furniture & Fixtures |
|
| 1-2 |
********** |
********** |
********** |
********** |
********** |
********** |
********** |
| 2-3 |
********** |
********** |
********** |
********** |
********** |
********** |
********** |
| 3-4 |
********** |
********** |
********** |
********** |
********** |
********** |
********** |
| 4-5 |
********** |
********** |
********** |
********** |
********** |
********** |
********** |
| 5-6 |
********** |
********** |
********** |
********** |
********** |
********** |
********** |
| Particulars |
Method |
Deprn.Rate |
Part Consideration (for Asset put to use less than xx
months)
|
|
|
|
|
| Type A :: Buildings |
|
|
|
|
|
|
|
| Factory Building - |
WDV |
********** |
********** |
|
|
|
|
| Office Buildings |
WDV |
********** |
********** |
|
|
|
|
| Type C |
|
|
|
|
|
|
|
| Office Vehicles |
WDV |
********** |
********** |
|
|
|
|
| Type D :: Misc. Fixed Assets |
|
|
|
|
|
|
|
| Office Automation Equipments (Telephone/ Fax/ Computer) |
WDV |
********** |
********** |
|
|
|
|
| Furniture & Fixtures |
WDV |
********** |
********** |
|
|
|
|
Projected Pay Back Period
| Particulars |
Operating Years |
|
1-2 |
2-3 |
3-4 |
4-5 |
5-6 |
| Year |
1 |
2 |
3 |
4 |
5 |
| Initial Investment |
********* |
|
|
|
|
| Total Initial Investment |
********* |
|
|
|
|
| Yearly Cash Flow |
********* |
********* |
********* |
********* |
********* |
| Accumulated Cash Flow |
********* |
********* |
********* |
********* |
********* |
| Pay Back Period |
xx Years xx Months |
xx Years xx months |
|
|
Projected IRR
| Year |
CFAT |
PV factor @**% |
********* |
| Initial Investment |
********* |
********* |
********* |
| 1-2 |
********* |
********* |
********* |
| 2-3 |
********* |
********* |
********* |
| 3-4 |
********* |
********* |
********* |
| 4-5 |
********* |
********* |
********* |
| 5-6 |
********* |
********* |
********* |
| Total PV |
********* |
|
********* |
| IRR |
********* |
|
********* |
|
|
|
|
PROJECTED BALANCE SHEET
| Particulars |
Operating Years |
|
1-2 |
2-3 |
3-4 |
4-5 |
5-6 |
|
|
|
|
|
|
| Equity Share Capital |
********** |
********** |
********** |
********** |
********** |
| Surplus of Previous Year |
********** |
********** |
********** |
********** |
********** |
| Add : Net Profit After Taxes |
********** |
********** |
********** |
********** |
********** |
| Surplus at the End of Year |
********** |
********** |
********** |
********** |
********** |
| Unsecured Deposits |
********** |
********** |
********** |
********** |
********** |
| Long/Medium Term Borrowings Proposed-FROM BANK |
********** |
********** |
********** |
********** |
********** |
| Bank Borrowing for Wkg. Capital |
********** |
********** |
********** |
********** |
********** |
| Current Liabilities |
********** |
********** |
********** |
********** |
********** |
| Sundry Creditors |
********** |
********** |
********** |
********** |
********** |
|
Other Current
Liabilities
|
********** |
********** |
********** |
********** |
********** |
| Total Current Liabilities |
********** |
********** |
********** |
********** |
********** |
|
|
********** |
********** |
********** |
********** |
********** |
| Total of Liabilities |
********** |
********** |
********** |
********** |
********** |
|
********** |
********** |
********** |
********** |
********** |
| A S S E T S |
********** |
********** |
********** |
********** |
********** |
| Fixed Assets |
********** |
********** |
********** |
********** |
********** |
| Gross Block |
********** |
********** |
********** |
********** |
********** |
| Less : Depreciation to Date |
********** |
********** |
********** |
********** |
********** |
| Net Block |
********** |
********** |
********** |
********** |
********** |
| Current Assets |
********** |
********** |
********** |
********** |
********** |
| Stocks on Hand |
********** |
********** |
********** |
********** |
********** |
|
Receivables
|
********** |
********** |
********** |
********** |
********** |
| Other Current Assets |
********** |
********** |
********** |
********** |
********** |
| Cash and Bank Balances |
********** |
********** |
********** |
********** |
********** |
| Total Current Assets |
********** |
********** |
********** |
********** |
********** |
| P & P Exp. and/or Other Dvp.Exp. |
********** |
********** |
********** |
********** |
********** |
| (To The Extent Not W/Off) |
********** |
********** |
********** |
********** |
********** |
| Other Non Current Assets |
********** |
********** |
********** |
********** |
********** |
|
|
********** |
********** |
********** |
********** |
********** |
| Total of Assets |
********** |
********** |
********** |
********** |
********** |
|
********** |
********** |
********** |
********** |
********** |
| ROI (Average of Fixed Assets) |
********** |
********** |
********** |
********** |
********** |
| RONW (Average of Share Capital) |
********** |
********** |
********** |
********** |
********** |
| ROI (Average of Total Assets) |
********** |
********** |
********** |
********** |
********** |
COMPANY SUMMARY
NIIR PROJECT CONSULTANCY SERVICES (NPCS)is a reliable name in the industrial world for offering integrated technical consultancy services. NPCS is manned by engineers, planners, specialists, financial experts, economic analysts and design specialists with extensive experience in the related industries.
Our various services are: Detailed Project Report, Business Plan for Manufacturing Plant, Start-up Ideas, Business Ideas for Entrepreneurs, Start up Business Opportunities, entrepreneurship projects, Successful Business Plan, Industry Trends, Market Research, Manufacturing Process, Machinery, Raw Materials, project report, Cost and Revenue, Pre-feasibility study for Profitable Manufacturing Business, Project Identification, Project Feasibility and Market Study, Identification of Profitable Industrial Project Opportunities, Business Opportunities, Investment Opportunities for Most Profitable Business in India, Manufacturing Business Ideas, Preparation of Project Profile, Pre-Investment and Pre-Feasibility Study, Market Research Study, Preparation of Techno-Economic Feasibility Report, Identification and Selection of Plant, Process, Equipment, General Guidance, Startup Help, Technical and Commercial Counseling for setting up new industrial project and Most Profitable Small Scale Business.
NPCS also publishes varies process technology, technical, reference, self employment and startup books, directory, business and industry database, bankable detailed project report, market research report on various industries, small scale industry and profit making business. Besides being used by manufacturers, industrialists and entrepreneurs, our publications are also used by professionals including project engineers, information services bureau, consultants and project consultancy firms as one of the input in their research.
REASONS FOR BUYING THE REPORT
- This report helps you to identify a profitable project for investing or diversifying into by throwing light to crucial areas like industry size, demand of the product and reasons for investing in the product.
- This report provides vital information on the product like its definition, characteristics and segmentation.
- This report helps you market and place the product correctly by identifying the target customer group of the product.
- This report helps you understand the viability of the project by disclosing details like raw materials required, manufacturing process, project costs and snapshot of other project financials.
- The report provides forecasts of key parameters which helps to anticipate the industry performance and make sound business decision.
OUR APPROACH
- Our research reports broadly cover Indian markets, present analysis, outlook and forecast.
- The market forecasts are developed on the basis of secondary research and are cross-validated through interactions with the industry players.
- We use reliable sources of information and databases. And information from such sources is processed by us and included in the report.
TABLE OF CONTENT
Introduction
Project Introduction
Project Objective and Strategy
Concise History of the Product
Properties
BIS (Bureau of Indian Standards) Provision & Specification
Uses & Applications
Market Study and Assessment
Current Indian Market Scenario
Present Market Demand and Supply
Estimated Future Market Demand and Forecast
Statistics of Import & Export
Names & Addresses of Existing Units (Present Players)
Market Opportunity
Raw Material
List of Raw Materials
Properties of Raw Materials
Prescribed Quality of Raw Materials
List of Suppliers and Manufacturers
Personnel (Manpower) Requirements
Requirement of Staff & Labor (Skilled and Unskilled) Managerial,
Technical, Office Staff and Marketing Personnel
Plant and Machinery
List of Plant & Machinery
Miscellaneous Items
Appliances & Equipments
Laboratory Equipments & Accessories
Electrification
Electric Load & Water
Maintenance Cost
Sources of Plant & Machinery (Suppliers and Manufacturers)
Manufacturing Process and Formulations
Detailed Process of Manufacture with Formulation
Packaging Required
Process Flow Sheet Diagram
Infrastructure and Utilities
Project Location
Requirement of Land Area
Rates of the Land
Built Up Area
Construction Schedule
Plant Layout and Requirement of Utilities
FINANCIAL PLAN
Assumptions for Profitability workings |
Plant Economics |
Production Schedule |
Land & Building
- Factory Land & Building
- Site Development Expenses
|
Plant & Machinery
- Indigenous Machineries
- Other Machineries (Miscellaneous, Laboratory etc.)
|
Other Fixed Assets
- Furniture & Fixtures
- Pre-operative and Preliminary Expenses
- Technical Knowhow
- Provision of Contingencies
|
Working Capital Requirement Per Month
- Raw Material
- Packing Material
- Lab & ETP Chemical Cost
- Consumable Store
|
Overheads Required Per Month And Per Annum
- Utilities & Overheads (Power, Water and Fuel Expenses etc.)
- Royalty and Other Charges
- Selling and Distribution Expenses
|
Salary and Wages
|
Turnover Per Annum
|
Share Capital
- Equity Capital
- Preference Share Capital
|
Annexure 1:: Cost of Project and Means of Finance
|
Annexure 2:: Profitability and Net Cash Accruals
- Revenue/Income/Realisation
- Expenses/Cost of Products/Services/Items
- Gross Profit
- Financial Charges
- Total Cost of Sales
- Net Profit After Taxes
- Net Cash Accruals
|
Annexure 3 :: Assessment of Working Capital requirements
- Current Assets
- Gross Working. Capital
- Current Liabilities
- Net Working Capital
- Working Note for Calculation of Work-in-process
|
Annexure 4 :: Sources and Disposition of Funds
|
Annexure 5 :: Projected Balance Sheets
- ROI (Average of Fixed Assets)
- RONW (Average of Share Capital)
- ROI (Average of Total Assets)
|
Annexure 6 :: Profitability ratios
- D.S.C.R
- Earnings Per Share (EPS)
- Debt Equity Ratio
|
Annexure 7 :: Break-Even Analysis
- Variable Cost & Expenses
- Semi-Var./Semi-Fixed Exp.
- Profit Volume Ratio (PVR)
- Fixed Expenses / Cost
- B.E.P
|
Annexure 8 to 11:: Sensitivity Analysis-Price/Volume
- Resultant N.P.B.T
- Resultant D.S.C.R
- Resultant PV Ratio
- Resultant DER
- Resultant ROI
- Resultant BEP
|
Annexure 12 :: Shareholding Pattern and Stake Status
- Equity Capital
- Preference Share Capital
|
Annexure 13 :: Quantitative Details-Output/Sales/Stocks
- Determined Capacity P.A of Products/Services
- Achievable Efficiency/Yield % of Products/Services/Items
- Net Usable Load/Capacity of Products/Services/Items
- Expected Sales/ Revenue/ Income of Products/ Services/ Items
|
Annexure 14 :: Product wise domestic Sales Realisation |
Annexure 15 :: Total Raw Material Cost |
Annexure 16 :: Raw Material Cost per unit |
Annexure 17 :: Total Lab & ETP Chemical Cost |
Annexure 18 :: Consumables, Store etc., |
Annexure 19 :: Packing Material Cost |
Annexure 20 :: Packing Material Cost Per Unit |
Annexure 21 :: Employees Expenses |
Annexure 22 :: Fuel Expenses |
Annexure 23 :: Power/Electricity Expenses |
Annexure 24 :: Royalty & Other Charges |
Annexure 25 :: Repairs & Maintenance Exp. |
Annexure 26 :: Other Mfg. Expenses |
Annexure 27 :: Administration Expenses |
Annexure 28 :: Selling Expenses |
Annexure 29 :: Depreciation Charges – as per Books (Total) |
Annexure 30 :: Depreciation Charges – as per Books (P & M) |
Annexure 31 :: Depreciation Charges - As per IT Act WDV (Total) |
Annexure 32 :: Depreciation Charges - As per IT Act WDV (P & M) |
Annexure 33 :: Interest and Repayment - Term Loans |
Annexure 34 :: Tax on Profits |
Annexure 35 ::Projected Pay-Back Period And IRR |
INFORMATION/ DISCLAIMER
- One Lac / Lakh / Lakhs is equivalent to one hundred thousand (100,000)
- One Crore is equivalent to ten million (10,000,000)
- T.C.I is Total Capital Investment
- We can modify the project capacity and project cost as per your requirement.
- We can also prepare project report on any subject as per your requirement.
- Caution: The project's cost, capacity and return are subject to change without any notice. Future projects may have different values of project cost, capacity or return.
